#import <Foundation/Foundation.h>
// This includes the header for the SQLite library. 
#import <sqlite3.h> 
#import "Programme.h"
#import "Department.h"

@interface DataAccess : NSObject {
}
+ (NSArray*) getAllProgrammes;
+ (NSArray*) getProgrammesInDepartment:(NSString*)dept ;
+ (void) closeDatabase; 
+ (void)initializeDatabase;
+ (Department*) getDepartment:(NSString*)abbreviation;
+ (sqlite3_stmt *)prepareSQL:(NSString*)sql;
+ (NSString*)getStringFrom:(sqlite3_stmt*)sql InCol:(int)col;

@end